DataCraft Mastering Analytics with Google Sheets, SQL, and Beyond

Prerequisite

Basic computer literacy and familiarity with spreadsheets

Course Description

Build a strong foundation in data analytics using Google Sheets, SQL, Power Query, and VBA. Learn how to explore, clean, visualize, and extract value from data with hands-on tools and real-world examples.

What you will learn

• - Perform exploratory data analysis in Google Sheets
• - Clean and format data using formulas and tools
• - Query and manage databases using SQL
• - Build dashboards and apply statistical models
• - Automate and visualize data with Power Query and VBA

Course Outline

• Week 1 Introduction to Data Analytics

  • Understanding the role of data analytics in decision-making
  • Introduction to data-driven insights
  • Overview of tools: Sheets, SQL, VBA, Power Query
  • Exploring industry case studies
  • Hands-on: Analyze a sample business problem

• Week 2 Data Exploration and Visualization in Google Sheets

  • Sorting, filtering, and summarizing data
  • Using pivot tables to uncover patterns
  • Creating charts and applying conditional formatting
  • Hands-on: Analyze a dataset to uncover trends

• Week 3 Introduction to Data and Databases (SQL)

  • Understanding relational databases and SQL basics
  • Basic SQL commands: SELECT, WHERE, ORDER BY
  • Hands-on practice with SQLite or MySQL
  • Hands-on: Query sample student or sales database

• Week 4 Data Cleaning and Preprocessing

  • Handling missing/inconsistent data
  • Removing duplicates and standardizing formats
  • Using formulas to transform data
  • Hands-on: Clean a messy dataset for analysis

• Week 5 Exploratory Data Analysis (EDA)

  • Calculating descriptive statistics
  • Analyzing relationships and distributions
  • Visualizing insights using Sheets
  • Hands-on: EDA on customer or academic dataset

• Week 6 Statistical Fundamentals for Data Analysis

  • Intro to probability and hypothesis testing
  • Correlation and regression basics
  • Applying stats to real-world decisions
  • Hands-on: Apply formulas to analyze scenarios

• Week 7 Mail Merge for Student ID Cards

  • Preparing Excel with student info
  • Designing ID templates in Word
  • Linking data with Word mail merge
  • Hands-on: Generate and export ID cards as PDF

• Week 8 VBA Programming Basics in Excel

  • Declaring variables and writing functions
  • Loops, conditionals, and message boxes
  • UserForms for input and automation
  • Hands-on: Create a mini Excel automation tool

• Week 9 Predictive Analytics with Google Sheets

  • Linear regression for forecasting
  • Evaluating model performance (R, RMSE)
  • Hands-on: Forecast sales or grades using Sheets

• Week 10 Time Series Analysis in Google Sheets

  • Moving averages and smoothing techniques
  • Trend and seasonality detection
  • Hands-on: Analyze website or financial data

• Week 11 Power Query for Data Automation

  • Importing and cleaning data
  • Filtering, splitting, merging, and pivoting
  • Hands-on: Automate a complete ETL process

• Week 12 Case Studies and Capstone Project

  • Integrating SQL with Sheets
  • Analyzing industry-specific case studies
  • Capstone: Build an analytics report from raw data
  • Present findings and get feedback

Grading Criteria

Particulars	Marks (%)
Quizzes	20
Class Participation/ Attendance	15
Projects	25
Final Projects	40
Total	100